package com.cetc.sdp.mzga.service.server;

import java.util.List;

import com.cetc.sdp.mzga.service.pojo.QueryResult;

public interface StatServer {

	//get the distinct phone mac from the wifi basic table through device_num and time
	public List<String> getPhoneMacByDeviceNum(String starttime,String endtime,String deivicenum) throws Exception;
	
	//get the query results (phone mac ,startTime,endTime) from the wifi basic table through device_num and time
	public List<QueryResult> qureyRowsByDeviceNum(String starttime,String endtime,String deivicenum) throws Exception;
	
	//count all rows from the wifi basic table through device_num and time
	public int countRowsByDeviceNum(String starttime,String endtime,String deivicenum) throws Exception;
	
	//get the query results (device num ,startTime,endTime) from the wifi basic analyse  table through phone mac and time
	public List<QueryResult> getDNumTimeByPhoneMac(String starttime,String endtime,String phonemac) throws Exception;
	
	//count all rows from the wifi basic analyse  table through phone mac and time
	public int countRowsByPhoneMac(String starttime,String endtime,String phonemac) throws Exception;
}
